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