UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VPmHF323hV+BfzNyHSk9u6jSWPI+sNV5ubm/3t3j3Rg='
WHERE
key_id = 'c13a4b585f69d1d5b8efc085f8187e6eaa396d259e6e1501ff98c157b52025cf'
AND (
token = 'VPmHF323hV+BfzNyHSk9u6jSWPI+sNV5ubm/3t3j3Rg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)