UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z8ZicX+qGlTCopAcYjZEE3j6UHHfiMGZfVegiF0BoSM='
WHERE
key_id = '7d150bba0a265705f888535f40a32cf181fa0a3f9585c51e47c8341001d45767'
AND (
token = 'Z8ZicX+qGlTCopAcYjZEE3j6UHHfiMGZfVegiF0BoSM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)