UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Z6hP55uW03ZsUHb/WRx2IRV4Fd+aBeiypzxJ3+7E3w='
WHERE
key_id = '76826290b4e79e27b4b689d31cc9c831a724c00a07c2b6f082794bdf911bb304'
AND (
token = '8Z6hP55uW03ZsUHb/WRx2IRV4Fd+aBeiypzxJ3+7E3w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)