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