UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QKgD713NcwxvtpkDSGnDSA/xDYd6kDuRufbdhQs5bMg='
WHERE
key_id = 'e9088f994200f762dbc6a5f216ceb16280f09bdb4c724203d05473d3884afdfc'
AND (
token = 'QKgD713NcwxvtpkDSGnDSA/xDYd6kDuRufbdhQs5bMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)