UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YgbpavDArfPXe64WQj5s2GY80HIwKv1AM5fN8UtFFS8='
WHERE
key_id = 'b1d3cd1a4264cf27b899e05873a83716870dced3b83bac5791be2d6c3efc9ab1'
AND (
token = 'YgbpavDArfPXe64WQj5s2GY80HIwKv1AM5fN8UtFFS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)