UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c6wJvttANBvvhSwX7Iei2YYCWPD8q8BaB3hij6/Gs+w='
WHERE
key_id = '709325031ba216bd84c1fae23dc69df97a00fdc345ab3fd01745da1c3f6b6c09'
AND (
token = 'c6wJvttANBvvhSwX7Iei2YYCWPD8q8BaB3hij6/Gs+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)