UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6lmitpuiW8kKz1b2JSxgIfDZ5cyCxG8PgGu3tmsLmIk='
WHERE
key_id = '01181d19b5a9bef6678fdaeacfd31b00e24bce0859c2b3d1ff07d99f61271712'
AND (
token = '6lmitpuiW8kKz1b2JSxgIfDZ5cyCxG8PgGu3tmsLmIk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)