UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C2sQrxthR7tFVk1fL7WGVb7x903qGoHBXWqO6up/OBI='
WHERE
key_id = '4be10fc792859916a2306f92abbf2b86bdce094862db43f1068561e2b100eee9'
AND (
token = 'C2sQrxthR7tFVk1fL7WGVb7x903qGoHBXWqO6up/OBI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)