UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r1Kr7ohzUrXX9SjFfX3/YEr5bcZP58qkQdZMBmK3474='
WHERE
key_id = 'e2f2bf7c3dd9f50e49164ff2998d42ae7d0b18e964adf9060464ef24902bf54b'
AND (
token = 'r1Kr7ohzUrXX9SjFfX3/YEr5bcZP58qkQdZMBmK3474='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)