UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k1tlHBcoVbCKmU2Gi9O3pI9Uwr4t9YnZGMGIOzr5kl0='
WHERE
key_id = '384f101c7e44771c2a644357953985be405e049d9b43cdf3ce1eaae528cfacd9'
AND (
token = 'k1tlHBcoVbCKmU2Gi9O3pI9Uwr4t9YnZGMGIOzr5kl0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)