UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kN1dpH7grf4mlWq2gOcljJZtfnnABBoJGL64GjUFUW8='
WHERE
key_id = 'f8da4b658e995c07770b8bc6ad3fc3a05a5fcc3a6813a43169e2f063dab4dbd3'
AND (
token = 'kN1dpH7grf4mlWq2gOcljJZtfnnABBoJGL64GjUFUW8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)