UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gcW9HoXbPlt94aN/M9Gnz2+Re3GQZVNRxeIDplAnoh8='
WHERE
key_id = 'bf603c36313665b63d2ce870a53a7444ccaad1e189e7a24fe8222977dad5c6f6'
AND (
token = 'gcW9HoXbPlt94aN/M9Gnz2+Re3GQZVNRxeIDplAnoh8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)