UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm0hE1qCiFfRMcK69eNP0tqh24mjr1Ubutt9ugS9uNc8='
WHERE
key_id = 'a40326fe8a6355e9b0b750e5d759cba9d90392582d6f3fa2d5e253b7d304a093'
AND (
token = 'm0hE1qCiFfRMcK69eNP0tqh24mjr1Ubutt9ugS9uNc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)