UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qQHy9fe4sYuNqb+N22jrsux0TK47ufXzG93B9Je/LIA='
WHERE
key_id = '0e16988aadc52ae8e5c2299f9247e2b48e074df318c2eebff31592cff4996f45'
AND (
token = 'qQHy9fe4sYuNqb+N22jrsux0TK47ufXzG93B9Je/LIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)