UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qVwRwyARvpJ+ZM0pma1mVs8jnqKivzF/5nC+OFNi27M='
WHERE
key_id = '1ec991f8bfd1455739a756250a5c662121cecb42b0df0d5dd99fa4f33ba5858e'
AND (
token = 'qVwRwyARvpJ+ZM0pma1mVs8jnqKivzF/5nC+OFNi27M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)