UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A7I3c6EizWtjDsdzmdKz9xKcLMCnJPLE1zOpMjJu4l4='
WHERE
key_id = '93793c9c2672a7f5fdb28d10519e1929d32bc199924028e4de7a9f40958e7230'
AND (
token = 'A7I3c6EizWtjDsdzmdKz9xKcLMCnJPLE1zOpMjJu4l4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)