UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nZxcHPN4TKn3lKUtadja9Hjrz1qbVCq2G+8FE7WsHKI='
WHERE
key_id = 'f1cf99b0e26ab681f7e4aed46cf5d995d967f783a031351473d06df27571f101'
AND (
token = 'nZxcHPN4TKn3lKUtadja9Hjrz1qbVCq2G+8FE7WsHKI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)