UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i4+bCZn5z1xHpQxho3T4//09+WXZeD5ScLQ+oMZdwuE='
WHERE
key_id = 'bc107d4d65bd9f795d19f5543e066f717a6a0836e5f898c6b3a6a361203affb6'
AND (
token = 'i4+bCZn5z1xHpQxho3T4//09+WXZeD5ScLQ+oMZdwuE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)