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