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