UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OA7heYvu+fPsjgorymiUfZPQPlf1FQwNm1zADY2onu8='
WHERE
key_id = '827454a53a1169e338cf627cd13c1561a2bb36442201d4c117c04c476a31dbe7'
AND (
token = 'OA7heYvu+fPsjgorymiUfZPQPlf1FQwNm1zADY2onu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)