UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8v97diQIunAUyFvKxOmwL0fMfaY/oPRbPFIv6XVNOTw='
WHERE
key_id = 'b7ba64738759c4c4e7024299299fe91382590e767a939c651a9861c5b7f81540'
AND (
token = '8v97diQIunAUyFvKxOmwL0fMfaY/oPRbPFIv6XVNOTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)