UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XVFqVBKGRzbOoUJY/vuvhy9QrM8EpBfC6/0ApTj2nfM='
WHERE
key_id = '686561a181fef8c256a59ed82a0aacbc1023e640c19458e90d8c413678951a22'
AND (
token = 'XVFqVBKGRzbOoUJY/vuvhy9QrM8EpBfC6/0ApTj2nfM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)