UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1XIFi/15Ui9N/uaQH3QK+2gaGgog0yvSpFtS5mFd9SA='
WHERE
key_id = '8c97707abf48533af4c5090dfe3a50907fb1d17bd60756baec2d0d348d39fdfa'
AND (
token = '1XIFi/15Ui9N/uaQH3QK+2gaGgog0yvSpFtS5mFd9SA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)