UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Ys9qkC47MLLsngPKyXDOCQGzfsyffYj2RnYFx9fznQ='
WHERE
key_id = '2f6b75cf12b335d177e99edcd2ba41ae031fc173918555876a6b0827b16b9595'
AND (
token = '1Ys9qkC47MLLsngPKyXDOCQGzfsyffYj2RnYFx9fznQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)