UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XEmOFD2d+dpgog1DJk5rz/JbgcA3EmR+aSWUNqBnlpc='
WHERE
key_id = '3214339d514935ccd22a0a2645541552ff59e830c6ae97e248a7700627d4d799'
AND (
token = 'XEmOFD2d+dpgog1DJk5rz/JbgcA3EmR+aSWUNqBnlpc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)