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