UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mPFmzP5GXWyceiEcbVjAzEOS7LblQNz2bLWUz6LTw78='
WHERE
key_id = '2989ee36c422f95c26020bf1a96f53552d7d112ccfecd38910f96ba7eb5ced08'
AND (
token = 'mPFmzP5GXWyceiEcbVjAzEOS7LblQNz2bLWUz6LTw78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)