UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r+93j0RS3+SJOs+HEXt3gewLdVmfv6D/gxYWKfllNtU='
WHERE
key_id = '0d824673fe4f29a3805669022bdd6a11d5548d5bd536f3496b813e329e485df1'
AND (
token = 'r+93j0RS3+SJOs+HEXt3gewLdVmfv6D/gxYWKfllNtU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)