UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KoZhscC6dZS0xG1nINvpUn61mnMG0N/u8251t5wePV4='
WHERE
key_id = '8a3fa929e256e9949e2f1b2b9f48c2935dcccd8bb8652f4a32d16a1364bebba1'
AND (
token = 'KoZhscC6dZS0xG1nINvpUn61mnMG0N/u8251t5wePV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)