UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HAbcsT0BDJ02A+D2b/MKghcF4RxDPkCNRwRed2393Rg='
WHERE
key_id = 'e96f087674db5fbd34993cf47b3e1431e20b862a212ebaf8a897f24232daf3cf'
AND (
token = 'HAbcsT0BDJ02A+D2b/MKghcF4RxDPkCNRwRed2393Rg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)