UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zP78hEVqZ/D6HpbyxjRZNY0AqT9CNweBsA+PikGAh/8='
WHERE
key_id = '52f5b943d96e55fcf58dcdf54f784b2eb1288802cb680423a8337a3e4f043be9'
AND (
token = 'zP78hEVqZ/D6HpbyxjRZNY0AqT9CNweBsA+PikGAh/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)