UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v7YYg69d7nnba7CLyiGCtKlY0gWUibuRJL3pWou5ZqM='
WHERE
key_id = 'bc627727981f6632cf19ea5d6d1d4488ab7eb10dbbce9accca3779dfd82ca951'
AND (
token = 'v7YYg69d7nnba7CLyiGCtKlY0gWUibuRJL3pWou5ZqM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)