UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gIQx2i1Yv8SYiBWhGajBvmwdjWqXuXHipiq2sdEAyPQ='
WHERE
key_id = '4ae273f5faf675639a2c7ae9a6e42b03dcfedfed980da6f02ddef9ade393982f'
AND (
token = 'gIQx2i1Yv8SYiBWhGajBvmwdjWqXuXHipiq2sdEAyPQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)