UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sGz1+rDWKlUB2ayXa3LqKIrqvK25k5CnpNWvO9ThoM4='
WHERE
key_id = 'a2de2b69a2fa19b23d42e29f517e83f991dd0506da2c36f2d62b08b32b9267c9'
AND (
token = 'sGz1+rDWKlUB2ayXa3LqKIrqvK25k5CnpNWvO9ThoM4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)