UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZV3bE7DoiU5MioOtfONbDARsY8t/9Iwu0xpXFyzrDUU='
WHERE
key_id = 'a839bd9c4beaa5eef92a36ab660855ffc8a61f9e65e8e75419543a590d9207c6'
AND (
token = 'ZV3bE7DoiU5MioOtfONbDARsY8t/9Iwu0xpXFyzrDUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)