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