UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mtYqddExTbRnvFUQ+QJYIZNTuiWNpoSWvDC9/PA4XjM='
WHERE
key_id = '788eaef8b52a2f23e54eef896f79cc51e9d0a2f20bf007717985088ed7960f65'
AND (
token = 'mtYqddExTbRnvFUQ+QJYIZNTuiWNpoSWvDC9/PA4XjM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)